SqlDateTime
- Category
- Structure
- Description
- Represents the date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds to be stored in or retrieved from a database. The System.Data.SqlTypes.SqlDateTime structure has a different underlying data structure from its corresponding .NET Framework type, System.DateTime, which can represent any time between 12:00:00 AM 1/1/0001 and 11:59:59 PM 12/31/9999, to the accuracy of 100 nanoseconds. System.Data.SqlTypes.SqlDateTime actually stores the relative difference to 00:00:00 AM 1/1/1900. Therefore, a conversion from "00:00:00 AM 1/1/1900" to an integer will return 0.
- Assembly
- System.Data
- Character
- sealed, public
- Attributes
-
Name Value/Assignment XmlSchemaProviderAttribute GetXsdType - Implements
- INullable, IComparable, IXmlSerializable
- Contstructors
- SqlDateTime(DateTime)
SqlDateTime(Int32,Int32)
SqlDateTime(Int32,Int32,Int32)
SqlDateTime(Int32,Int32,Int32,Int32,Int32,Int32)
SqlDateTime(Int32,Int32,Int32,Int32,Int32,Int32,Double)
SqlDateTime(Int32,Int32,Int32,Int32,Int32,Int32,Int32)- Properties
- DayTicks
IsNull
TimeTicks
Value- Methods
- Add(SqlDateTime,TimeSpan)
CompareTo(SqlDateTime)
CompareTo(Object)
Equals(SqlDateTime,SqlDateTime)
Equals(Object)
GetHashCode()
GetXsdType(XmlSchemaSet)
GreaterThan(SqlDateTime,SqlDateTime)
GreaterThanOrEqual(SqlDateTime,SqlDateTime)
LessThan(SqlDateTime,SqlDateTime)
LessThanOrEqual(SqlDateTime,SqlDateTime)
NotEquals(SqlDateTime,SqlDateTime)
op_Addition(SqlDateTime,TimeSpan)
op_Equality(SqlDateTime,SqlDateTime)
DateTime
SqlDateTime
op_GreaterThan(SqlDateTime,SqlDateTime)
op_GreaterThanOrEqual(SqlDateTime,SqlDateTime)
SqlDateTime
op_Inequality(SqlDateTime,SqlDateTime)
op_LessThan(SqlDateTime,SqlDateTime)
op_LessThanOrEqual(SqlDateTime,SqlDateTime)
op_Subtraction(SqlDateTime,TimeSpan)
Parse(String)
Subtract(SqlDateTime,TimeSpan)
GetSchema()
ReadXml()
WriteXml()
ToSqlString()
ToString()- Fields
- MaxValue
MinValue
Null
SQLTicksPerHour
SQLTicksPerMinute
SQLTicksPerSecond- Tags
- 01800F4D53, 02E3ABA98D, 0376596F91
- SqlDateTime(DateTime)
- Software for developers
-
.Net Components
Delphi Components
Software for Android Developers - More information resources
-
WinAPI Programmer's Reference
Unix Manual Pages
Delphi Examples - Databases for Amazon shops developers
-
Amazon Categories Database
Browse Nodes Database